﻿CREATE TABLE [dbo].[UserProfile] (
    [UserProfileId]   INT          IDENTITY (1, 1) NOT NULL,
    [UserId]          INT          NOT NULL,
    [FirstName]       VARCHAR (50) NULL,
    [LastName]        VARCHAR (50) NULL,
    [DOB]             DATETIME     NULL,
    [Address1]        VARCHAR (50) NULL,
    [Address2]        VARCHAR (50) NULL,
    [City]            VARCHAR (50) NULL,
    [State]           VARCHAR (50) NULL,
    [Zip]             VARCHAR (20) NULL,
    [UserField1]      VARCHAR (50) NULL,
    [UserField2]      VARCHAR (50) NULL,
    [UserField3]      VARCHAR (50) NULL,
    [adt_DateCreated] DATETIME     NOT NULL,
    [adt_CreatedBy]   VARCHAR (50) NULL,
    CONSTRAINT [PK_UserProfile] PRIMARY KEY CLUSTERED ([UserProfileId] ASC)
);

